﻿CREATE PROCEDURE dbo.AssortmentSelect
AS
	SET NOCOUNT ON;
SELECT Id, GId, CatalogId, Name, MedFormId, AssesmentGroupId, ABList, NotPatentedRus, NotPatentedLat, GNVLS, Mandatory, StoreTemperature, BeforeOverdue, NoRecipe, ReferentPrice, ReferentDate, Note, MD, MW FROM CA.Assortment